﻿
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sproc_Flow_GetAllBindMember]') AND type in (N'P', N'PC'))
    DROP PROCEDURE [dbo].[sproc_Flow_GetAllBindMember];
GO
CREATE PROCEDURE [dbo].[sproc_Flow_GetAllBindMember]
    @FlowID int,
    @StepID int
AS
SELECT b.*
    FROM 
        v_UDS_Flow_Staff_In_Step a,
        uds_staff b
    WHERE
        a.staff_id = b.staff_id
        and a.flow_id = @FlowID
        and a.step_id = @StepID